In [1]:
# This changes the current directory to the base saga directory - make sure to run this first!
# This is necessary to be able to import the py files and use the right directories,
# while keeping all the notebooks in their own directory.
import os
import sys

if 'saga_base_dir' not in locals():
    saga_base_dir = os.path.abspath('..')
if saga_base_dir not in sys.path:
    os.chdir(saga_base_dir)

In [2]:
import urllib
import requests
import webbrowser
import datetime

import numpy as np

#astropy >= v1.1 needed
from astropy import units as u
from astropy import table 
from astropy.coordinates import SkyCoord

%matplotlib inline
from matplotlib import pyplot as plt

import targeting #from SAGA

The actual catalogs were downloaded using the download_host_sqlfile.py file from https://github.com/saga-survey/marla to the data directory below


In [3]:
data_dir = '../local_data/'

run this to look at the rem list in the browser


In [4]:
webbrowser.open(targeting._DEFAULT_TREM_URL.replace('/export?format=csv&', '#'))


Out[4]:
True

Now save today's version


In [6]:
fnremlist = 'TargetRemove{}.csv'.format(datetime.datetime.now().strftime('%b%d_%Y'))

if not os.path.exists(fnremlist):
    urllib.request.urlretrieve(targeting._DEFAULT_TREM_URL, fnremlist)
fnremlist


Out[6]:
'TargetRemoveDec16_2015.csv'

Load the remove list as an Astropy table, and add a "row_index" to make it easier to look at in the notebook


In [7]:
remlist = table.Table.read(fnremlist, format='csv',data_start=3, header_start=1)
remlist.remove_column('col6') # google made a blank column for some reason?

remlist.add_column(remlist.ColumnClass(name='row_index', data=np.arange(len(remlist))), index=0)
remlist = remlist[~remlist['SDSS ID'].mask]

remlist.show_in_notebook(display_length=10)


Out[7]:
<Table masked=True length=393>
row_indexHost NameNSASDSS IDTarg_RATarg_Deccomment
0Hamlet1660351237662498391261226228.3895341.95437--
1Hamlet1660351237662300829384725228.77829342.209718--
2Hamlet1660351237662300829253660228.37358942.32577--
3Hamlet1660351237662300829384730228.7595842.217655--
4Hamlet1660351237662300829253654228.36882142.335368--
5Hamlet1660351237662300829253651228.37479242.330362--
6Hamlet1660351237662300829384720228.76335942.215231--
7Hamlet1660351237662300829189130228.23465842.295864--
8Hamlet1660351237662498928197694229.03846642.321874--
9Hamlet1660351237658205598712218228.24702241.844161--
10Hamlet1660351237658206135517869228.49870342.225523--
11Hamlet1660351237662300829253653228.36943342.330579--
12Hamlet1660351237662498391261232228.39969441.959533--
13Hamlet1660351237662498391130169228.15162442.088901--
14Hamlet1660351237662300829384747228.76406842.214973--
15Hamlet1660351237662498391326725228.68125842.043465--
16Hamlet1660351237662300829384723228.76249242.215609--
18Gilgamesh1663131237665565541597386233.79856716.548445--
19Gilgamesh1663131237665565541597396233.80135916.550769--
20Gilgamesh1663131237667783928971283234.23803116.062159--
21Gilgamesh1663131237665565541597393233.78881916.556174--
22Gilgamesh1663131237665565541597382233.79912916.54718--
23Gilgamesh1663131237668367995896029234.41787316.176608--
24Gilgamesh1663131237665565541597394233.7881316.552901--
25Gilgamesh1663131237668336320774200234.00752416.765775--
26Gilgamesh1663131237667783928971359234.32401616.065865--
27Gilgamesh1663131237665565004923042234.141235116.06926024star spike
28Gilgamesh1663131237665565004858351233.970311216.09952538star spike
29Gilgamesh1663131237665565004924107234.146595216.05419875star spike
30Gilgamesh1663131237668336857579628234.005943717.09853327shred
31----1237668335783968924234.004120116.12301278star spike
33AnaK619451237663784194801797354.0168290.0795873--
34AnaK619451237663784194801800354.0168150.0801771--
35AnaK619451237663784194801799354.01711970.07785658--
36AnaK619451237666408439939280354.34940110.39667053--
37AnaK619451237663277925007626353.73395980.49841161--
38AnaK619451237666408439939277354.34991430.3917256--
39AnaK619451237663277925335175354.45441850.5714453306--
40AnaK619451237666408439873560354.12709990.28367036--
41AnaK619451237657190902530122353.9476243-0.1356747--
42AnaK619451237657190902858011354.571808-0.05123042--
43AnaK619451237663784194671628353.81375770.050898988--
44AnaK619451237663784194605286353.62844850.172251683--
45AnaK619451237657191976599705354.62815120.680931245--
46AnaK619451237663783657996411354.1831579-0.40931472--
47AnaK619451237663277925467111354.78728450.454610128--
48AnaK619451237663277925204613354.19211690.6290792209--
49AnaK619451237663784194670736353.8059040.03908026366shredded
50AnaK619451237663784194670740353.81028390.04187874978shredded
53Aeneid1487341237652935103676444310.0543489-5.783606789--
54Aeneid1487341237652935103676437310.056789-5.7826849--
55Aeneid1487341237652935103676433310.0563008-5.785524714--
57Alice1405941237650762927570986180.2855078-1.441528804--
58Alice1405941237674648854921317179.8642061-1.156301836--
59Alice1405941237674649391857948180.1293214-0.695983535--
60Alice1405941237674649391988842180.3622875-0.720470482--
61Alice1405941237650762927702028180.6098101-1.488209133--
62Alice1405941237648720693952627180.1647985-0.4952457719--
63Alice1405941237650371555623210179.881864-1.742935915--
64Alice1405941237674648854659340179.3861043-1.258124142shred of massive galaxy
65Alice1405941237674648854659334179.3826082-1.252963848shred of massive galaxy
66Alice1405941237648720157081640180.221537681-0.921871703309shred of merger
67Alice1405941237674648854659347179.372884669-1.24092352087shred of spiral
68Alice1405941237648720693690573179.609937665-0.550527341235minor shred
69--1405941237650372092559950180.0277199-1.31238173722--
70--1405941237674649391924335180.251138748-0.826766889108star spike
71--1405941237674649391858392180.096191678-0.674222336493star spike
72--1405941237674649391858693180.095856258-0.671956369284star spike
73--1405941237674648854855886179.817570821-1.11138864573shred of spiral
74--1405941237650371555819885180.315794624-1.73185028005star spike
77Iliad1502381237680064809927114342.8918986-5.610564608--
78Iliad1502381237680064809861229342.7393734-5.56160845--
80Ulysses1503401237656906348167410344.1945902-0.9978173971--
82--130625123767862223942476027.746856834.1817563bright star wing
83--130625123767866197331173628.510195254.593321799moving object
84--130625123767862223935918327.576034224.057899478shred of massive galaxy
85--130625123767862331355961928.605500224.805294169shred of massive galaxy
86--130625123767862277629608027.74785114.531434674star spike
87--130625123767862331349416628.492548484.888903287double nucleus
89--131531123767001458324288833.912211825.652888348star spike
90--131531123767001458298067233.333816275.756103586shred
91--131531123766722822327526333.98183126.204009574shred
92--131531123766722768646974334.10685345.723417469HI region
93--131531123766722876021165234.169592856.570152826star spike
94--131531123767001458330838734.065399295.538636513star spike
95--131531123767001511998269133.590264346.028925956star spike
96--131531123766722876021163734.172106786.572001036star spike
97--131531123766722876021164434.171046816.572490431star spike
98--131531123766722876021165634.171872546.580759921star spike
99--131531123766722876021168634.178426676.570043726star spike
100--131531123767001512031037434.300197216.004875032shred
101--131531123766722876021160434.172034426.562866184star spike
103--132339123766002452103181739.46781726-1.143523316--
104--132339123767888157494485439.86604461-1.277385371shred
106--12611512376802478884786180.759831098921.00467809noise near bright star
107--12611512376802468147365220.801696159620.33184714moving object
109--129387123767892021372551221.2023199512.54237176star spike
110--129387123767886062819740721.3338888213.11025026shred of larger galaxy
111--129387123764991843133031020.6835110713.22485156star spike
112--129387123767892075059614521.3214761513.01961332star spike
113--129387123767892075059614621.3206270413.01532781star spike
114--129387123767892075059614721.3207833513.01596598star spike
115--129387123767892075066173621.3985061712.89799881star spike
117--857461237664871900119158149.290510532.98970045star spike
118--857461237664871900185482149.564488133.00609603star spike
119--857461237664871900119173149.294922232.98741894star spike
120--857461237664871900119174149.294148532.99387801star spike
121--857461237664871900119181149.29514633.00088263star spike
122--857461237664879416181033149.785170832.42598509star spike
123--857461237664879416049673149.498323632.24372568HII region
124--857461237664870826639438149.707217232.07231369spiral arm
125--857461237664879415853949149.020942232.27440651star spike
126--857461237664337706156587149.819014331.78134893star spike
127--857461237664871900185220149.574856333.0488752star spike
128--857461237664871900185217149.57259633.04764016star spike
129--857461237664871900119180149.296621732.99089205star spike
130--857461237664871900119327149.312128732.98504379star spike
131--857461237664871363117423148.924726132.6575022star spike
132--857461237664879416116195149.655250732.37535926star spike
133--857461237664871900119191149.297614832.99248793star spike
134--857461237664338242962147149.443839132.01556355star spike
135--857461237664879415853951149.032456832.2377849star spike
136--857461237664871900119164149.294681832.99411251star spike
137--857461237664871900119194149.293845932.99678623star spike
138--857461237664879416049782149.604985632.36700809shred
139--857461237664338243158155149.99937132.33227938star spike
140--857461237662223517811271149.267222632.97946985star spike
141--857461237664878879047806149.344354531.74616873merger tail
142--857461237664878879375459150.264694832.17768562misclassified
144--334461237657607497384510123.285753836.27676563likely tidal feature from primary
145--334461237657594612810071123.4271136.5753satellite trail
146--334461237657594612875394123.475821236.65209819satellite trail
147--334461237657594612613331122.9554636.13238905part of larger spiral
148--334461237657594612809881123.254207736.53263262part of merger
149--334461237657607497384178123.291112136.27196738star shred
150--334461237657594075807834123.458787736.09972888star spike
151--334461237657594075807758123.383968736.03845282misclassified galaxy
152--334461237657594612678694123.058469236.34474181star shred
155--132339123766002452116311839.6905191-1.240192027not there?
156--132339123767888103787735439.47088333-1.664176936tidal tail of larger galaxy
157--132339123765758494998547839.68849299-0.9835482698tidal companion
159--1457291237648702984553095224.6328147-1.079987716part of main galaxy
160--1457291237655693551796297224.2756439-0.9749176907star spike
161--1457291237655693552058398224.8513685-0.9369250115star spike
162--1457291237655693551796680224.3053977-0.9933273332second part of merging galaxy
163--1457291237655499747164344224.1269892-1.265718049shred
164--1457291237655693551796650224.2301133-0.9903793954second part of merging galaxy
165--1457291237648703521554658224.9393172-0.6272479811second part of merging galaxy
167--321237648721752555641145.59153370.3097698893bit of larger galaxy
168--321237648721215684624145.574019-0.04952083427--
169--321237648721752621091145.73059430.2511563101shred
170--321237648721752621094145.73152470.2526045774shred
171--321237648721752621095145.73159810.2471176378shred
172--321237648721752621098145.73466780.2451407284shred
173--321237648721752555558145.60687450.3191398133shred of star
175--1655361237648704057050408221.8626044-0.3057260505star spike
176--1655361237648704057050409221.8638732-0.3042778795star spike
177--1655361237648704056787393221.2368418-0.3005513682second part of merger
178--1655361237648703519981589221.3734899-0.6247009016star spike
179--1655361237648703519981596221.3687812-0.6257746866star spike
180--1655361237648703519981597221.3682296-0.6248161704star spike
181--1655361237648703519850685221.0636814-0.6259872282star spike
182--1655361237648720712237216221.9478746-0.5396548915second part of merger
183--1655361237648720712237085221.9461438-0.4536277413shred
184--1655361237648704593592350221.04456380.1834074187shred
185--1655361237648721785914433221.79083880.3153469899star spike
186--1655361237648720712107151221.72266-0.49723079star spike
187--165536123764872124891147221.57195-0.19887408--
188--1655361237648721248911470221.57098-0.19708001--
190--139271237651735757324325180.79406511.962739469star spike
191--139271237651752936931860180.82075891.771710573star spke
192--139271237651735220388002180.68052311.59772897merger
193--139271237651752936931426180.72836821.751243222merger
194--139271237651735757324437180.85469251.942194355star
195--139271237651752936997146180.91573551.722676637merger
196--139271237651735220387926180.72586061.483454464merger
197--139271237651735220387927180.73115711.48206632merger
198--139271237651753473867956180.95547882.100210169shred
199--139271237651753473867954180.95314772.100966998merger
200--139271237651736293999101180.37376382.343191394star spike
201--139271237651736294129930180.69448692.401410663shred
202--139271237651735220256810180.34613291.646593137sat trail
203--139271237651753473933551181.17334572.120110586star spike
204--139271237651753473999601181.19064512.119739076star spike
206--1497811237679996084551744335.8068201-3.40787382shredded star
207--1497811237679996084683042336.2046149-3.37285556shredd galaxy
208--1497811237680192048726285335.7671939-3.45669501shred galaxy
210--1508871237678777399443945348.69570664.648493306shred galaxy
211--1508871237678777399443486348.696744.636643778shred galaxy
212--1508871237678777399509172348.87128274.613763855--
213--1508871237678777399443510348.72972824.716392095--
214--1508771237678777399247805348.1848074.681784804--
215--1508771237679005021700191348.2595014.508406536--
216--1508771237679005558636614348.46362734.905022479shred galaxy
218--129237123767916930465797020.2322414217.49849757star spike
219--129237123767916984152890120.3092414117.81300887star spike
224--1508871237678777399509169348.87547074.614633999shred galaxy <semiauto-found>
225--1508871237678777399509171348.87488974.612996446shred galaxy <semiauto-found>
226--1508871237678777399509175348.87331244.616120286shred galaxy <semiauto-found>
227--1508871237678777399509177348.87562474.612707788shred galaxy <semiauto-found>
228--1508871237678777399509173348.87177264.614206034shred galaxy <semiauto-found>
229--1508871237678777399509174348.87255084.612810864shred galaxy <semiauto-found>
230--1508871237678777399509179348.86938024.613929468shred galaxy <semiauto-found>
231--1508871237679005021700193348.26275984.511024978shred galaxy <semiauto-found>
232--1508871237679005021700198348.26275294.511561979shred galaxy <semiauto-found>
233--1508871237679005021700288348.39425034.552772309shred galaxy <semiauto-found>
234--1508871237679005021700293348.39500394.55037932shred galaxy <semiauto-found>
235--1508871237679005021700292348.39349944.55007271shred galaxy <semiauto-found>
236--1508871237679005021765925348.39947024.567074821shred galaxy <semiauto-found>
237--1508871237679005021765929348.39974194.567842711shred galaxy <semiauto-found>
238--1508871237679005021831464348.62079264.378087317shred galaxy <semiauto-found>
239--1508871237679005021962537348.94709924.53092546shred galaxy <semiauto-found>
240--1508871237679005022028541349.06508254.497889621star spike
241--1508871237679005022028542349.06690654.496766323star spike
242--1508871237679005558636613348.46313564.904934826shred galaxy <semiauto-found>
243--1508871237679005558636616348.46348464.907482859shred galaxy <semiauto-found>
244--1508871237679005558636619348.46120454.90438764shred galaxy <semiauto-found>
245--1508871237679005558636621348.4607034.904467179shred galaxy <semiauto-found>
246--1508871237679005558636865348.47903584.884018334shred galaxy <semiauto-found>
247--1508871237679005558637017348.39964374.866732323shred galaxy <semiauto-found>
248--1508871237679005558637018348.39978224.867484181shred galaxy <semiauto-found>
249--1508871237679005558702453348.6501224.877933283shred galaxy <semiauto-found>
250--1508871237679005558767960348.68950734.922046477shred galaxy <semiauto-found>
251--1508871237679005558833483348.89577854.834275971shred galaxy <semiauto-found>
252--1508871237679005558833491348.93716164.915840214shred galaxy <semiauto-found>
253--1508871237679005558636614348.46362734.905022479--
254--1508871237679005021700194348.2585524.51987099--
255--1508871237679005021700289348.39177684.557667469--
257--1505781237678859539448025346.143610812.26060821noise artifact
258--1505781237678859539448026346.143275912.26198846noise artifact
259--1505781237678859539710417346.736889512.17143482shred galaxy <semiauto-found>
260--1505781237678860076515632346.681876912.5783213shred galaxy <semiauto-found>
261--1505781237678920198979824346.714555512.34642846shred galaxy <semiauto-found>
262--1505781237678920198783047346.222545112.30378529--
263--1505781237678920198783050346.216518712.30575485--
264--1505781237678920198783058346.213368812.31512696--
265--1505781237678920198783068346.225295712.3005798--
267OBrother1497811237679996084617615336.0424634-3.307055428shred galaxy satellite/art
268OBrother1497811237679996084617622336.0430875-3.308617331shred galaxy satellite/art
269OBrother1497811237679996084617623336.0425695-3.307294956shred galaxy satellite/art
270OBrother1497811237679996084682961336.1307846-3.245994227shred galaxy <semiauto-found>
271OBrother1497811237679996084682967336.1282107-3.246489876shred galaxy <semiauto-found>
272OBrother1497811237679996084617518335.9804361-3.269670748shred galaxy <semiauto-found>
273OBrother1497811237679996084748653336.2398127-3.341441367shred galaxy <semiauto-found>
274OBrother1497811237680066954461498336.2339279-3.663585155shred galaxy <semiauto-found>
275--1497811237679996084617231335.9158625-3.42887141--
278--1503071237680064810516520344.306711-5.695469shred galaxy <semiauto-found>
279--1503071237680064810516514344.3068532-5.696343271shred galaxy <semiauto-found>
280--1503071237680064810516695344.2352586-5.536600883noise artifact
281--1503071237680064810516699344.2333971-5.535562918noise artifact
282--1503071237680116342128690343.8288738-5.735896191scattered light artifact
283--1503071237680116342128732343.8294351-5.733418471scattered light artifact
284--1503071237680116342128709343.8353918-5.727860568scattered light artifact
285--1503071237680116342128739343.8346146-5.727728845scattered light artifact
286--1503071237680116342128742343.834265-5.722005562scattered light artifact
287--1503071237680116342128746343.8336776-5.722660551scattered light artifact
288--1503071237680116342128743343.8419344-5.72585195scattered light artifact
289--1503071237680116342128750343.8426963-5.72754652scattered light artifact
290--1503071237680116342128744343.8361263-5.71889325scattered light artifact
291--1503071237680116342128763343.8362465-5.716902124scattered light artifact
292--1503071237680116342128767343.8349104-5.717821607scattered light artifact
293--1503071237680116879130861344.1317102-5.316218827shred galaxy <semiauto-found>
294--1503071237680116879196393344.2601029-5.500090538shred galaxy <semiauto-found>
295--1503071237680116879196394344.2611265-5.499761497shred galaxy <semiauto-found>
296--1503071237680065347059811343.6112483-5.233760003--
297--1503071237680065347256732344.0239496-5.158834491--
300AnaK619451237663277925335177354.45215520.5717430743shred galaxy <semiauto-found>
301AnaK619451237663277925335179354.45171040.5712535103shred galaxy <semiauto-found>
302AnaK619451237663277925335851354.52824030.5343066278shred galaxy <semiauto-found>
303AnaK619451237663784194801801354.0175240.0744706829shred galaxy <semiauto-found>
304AnaK619451237663784194801805354.01750180.0755611531shred galaxy <semiauto-found>
305AnaK619451237663784194802608354.02214940.06986532704shred galaxy <semiauto-found>
306AnaK619451237663784195063812354.61336670.2013047562star spike
307AnaK619451237663784195064879354.61476770.1993252941star spike
308AnaK619451237666408439612143353.6516210.3872835173shred galaxy <semiauto-found>
309--619451237663784194605204353.68434270.1278404295star spike
310--619451237657190902530119353.9507374-0.1327407029star spike
311--619451237663784194670743353.80825810.03515213013shred galaxy
312--619451237663784194670744353.81409430.04030397733shred
313--619451237663784194670746353.8074510.04944869333shred
314--619451237663784194670753353.80140940.0356422559shred
315--619451237663784194670764353.80167270.04084519771shred
316--619451237663784194670765353.81527830.04340013946shred
317--619451237663784194801795354.01619420.07986492997shred
318--619541237666408439939228354.30801770.4087636396shred
319--619451237666408440004744354.432580.3579006216--
320--619451237663784194670752353.81244490.03589864126--
322--1499771237678857925886378339.382812110.31307952shred galaxy <semiauto-found>
323--1499771237678857926017517339.685495210.47260362shred galaxy <semiauto-found>
324--1499771237678858462626161339.060107710.6498927shred galaxy <semiauto-found>
325--1499771237678858462757207339.467882210.7531606shred galaxy <semiauto-found>
326--1499771237678858462757209339.46728110.75221466shred galaxy <semiauto-found>
327--1499771237678858462757432339.349211510.83567213shred galaxy <semiauto-found>
328--1499771237679010927476977339.677574910.20942277shred galaxy <semiauto-found>d
329--1499771237678858462691406339.277510410.66412562--
330--1499771237678858462822803339.582717210.85063655--
331--1499771237679010927476978339.674464610.21052549--
332--1499771237678857925689519339.035452610.3559813--
334--15301712376795037820519040.0356566893119.9648746shred galaxy <semiauto-found>
335--1530171237679504318857642359.884309420.47951372shred galaxy <semiauto-found>
336--15301712376795043191851190.743337181220.38574162shred galaxy <semiauto-found>
337--15301712376795048559904160.50067313420.98720461shred galaxy <semiauto-found>
338--15301712376795048559904210.498317579720.9870445shred galaxy <semiauto-found>
339--15301712376795048559904220.50052828720.98757402shred galaxy <semiauto-found>
340--15301712376802468147368520.789950039920.35910528shred galaxy <semiauto-found>
341--1530171237680247351083137359.463925720.69770568shred galaxy <semiauto-found>
342--1530171237680247351083138359.464152520.69737833shred galaxy <semiauto-found>
343--1530171237680247351083141359.464556320.6969454shred galaxy <semiauto-found>
344--15301712376802473515420390.599304111220.68166076shred galaxy <semiauto-found>
345--1530171237680247888019633359.679552621.14766092shred galaxy <semiauto-found>
346--1530171237680247888019640359.677529321.14773798shred galaxy <semiauto-found>
347--1530171237680247888019639359.676798921.14948469shred galaxy <semiauto-found>
348--1530171237680247888019636359.674752521.1417034shred galaxy <semiauto-found>
349--1530171237680247888085341359.799624621.01209401noise artifact
350--1530171237680247888085471359.798221621.01104915noise artifact
351--1530171237680296744255765359.953639521.16115858star spike
352--1530171237680296744255771359.953367821.16272591star spike
353--1530171237680296744255773359.952906621.16394053star spike
354--1530171237680296744255774359.952492221.16655599star spike
355--1530171237680247351214677359.869876620.74238491--
356--1530171237680247351214130359.863776120.75131601--
357--1530171237680247888019634359.672929521.14081159--
359--129237123767860185051968720.1397307617.34349851shred galaxy <semiauto-found>
360--129237123767860185051968820.1374937617.34451981shred galaxy <semiauto-found>
361--129237123767860185065084020.4153651517.29491013noise artiface
362--129237123767860185065084320.4176668417.29484872noise artiface
363--129237123767860185065114420.3864418317.26723208shred galaxy <semiauto-found>
364--129237123767860185071672220.6519778217.30235502noise artifact
365--129237123767860185071672420.6526973817.30142806noise artifact
366--129237123767860185078190020.7882226817.28792472noise artifact
367--129237123767860185078196720.7883729417.28975247noise artifact
368--129237123767860185078190520.7781020517.29223071noise artifact
369--129237123767860185078190720.7798775717.29033252noise artifact
370--129237123767860238732553520.0791964417.73512094shred galaxy <semiauto-found>
371--129237123767860238745610220.2680762817.57900131shred galaxy <semiauto-found>
372--129237123767860238745610820.2674686117.57739308shred galaxy <semiauto-found>
373--129237123767860238745630420.3279058717.75338585shred galaxy <semiauto-found>
374--129237123767916930478902120.5357396517.5275968shred galaxy <semiauto-found>
375--129237123767916930465823420.2573862617.36696414shred galaxy <semiauto-found>
376--129237123767916930472355620.4193567217.38219709shred galaxy <semiauto-found>
377--129237123767916930472389820.4486251217.34729588noise artifact
378--129237123767916930472389920.4499280217.34804584noise artifact
379--129237123767916930485518020.7601614717.33295831star spike
380--129237123767916930485518420.761778717.33254073star spike
381--129237123767916984146396420.1470021517.84462893shred galaxy <semiauto-found>
382--129237123767916984172567420.7745992417.88975939shred galaxy <semiauto-found>
383--129237123767860238752165420.4639224617.60621566--
384--129237123767860185051970320.1575336917.34756677--
385--129237123767860238745610720.262019217.57931846--
386--129237123767916930492023820.8023223917.32114579--
388Narnia132339123766002452109790339.65634965-1.245097828shred galaxy <semiauto-found>
389Narnia132339123766002452109790439.65383793-1.245492657shred galaxy <semiauto-found>
390Narnia132339123767888103787736439.46768799-1.667585459shred galaxy <semiauto-found>
391Narnia132339123767888103787735639.46929951-1.6622428shred galaxy <semiauto-found>
392Narnia132339123767888103787735839.46676407-1.660034245shred galaxy <semiauto-found>
393Narnia132339123767888103787736139.46445312-1.659262884shred galaxy <semiauto-found>
394Narnia132339123767888103787736239.4676998-1.659933653shred galaxy <semiauto-found>
395Narnia132339123767888103794300739.62430852-1.760352276shred galaxy <semiauto-found>
396--132339123767889013755149939.6108927-1.430396371--
397--132339123767889013748537239.49555231-1.517742273star spike
399--12611512376795043191851190.743337181220.38574162shred galaxy <semiauto-found>
400--12611512376795043194471901.42244761820.47680278shred galaxy <semiauto-found>
401--12611512376795043194471911.42050157120.48091637shred galaxy <semiauto-found>
402--12611512376795043194471981.42174266320.47824808shred galaxy <semiauto-found>
403--12611512376795043194471991.41947719820.48001451shred galaxy <semiauto-found>
404--12611512376795043195126861.42328040520.47842523shred galaxy <semiauto-found>
405--12611512376795043194471941.41833711220.47936111shred galaxy <semiauto-found>
406--12611512376795043194471971.41783293320.47970895shred galaxy <semiauto-found>
407--12611512376795043195126871.42255351220.48171438shred galaxy <semiauto-found>
408--12611512376795043194471961.41691702720.47842819shred galaxy <semiauto-found>
409--12611512376795048559904160.50067313420.98720461shred galaxy <semiauto-found>
410--12611512376795048559904210.498317579720.9870445shred galaxy <semiauto-found>
411--12611512376795048559904220.50052828720.98757402shred galaxy <semiauto-found>
412--12611512376802468147368520.789950039920.35910528shred galaxy <semiauto-found>
413--12611512376802473515420390.599304111220.68166076shred galaxy <semiauto-found>
414--12611512376795043192505680.905597703620.46176508--
415--12611512376802473516729710.983559886420.74143047--
416--12611512376802473516729791.01099042520.76383535--
417--12611512376802473516729921.01411603220.76592848--
419--129387123767886009126116221.2378709912.85534644shred galaxy <semiauto-found>
420--129387123767892021352887620.7049319812.57925603shred galaxy <semiauto-found>
421--129387123767892021352891620.7993195212.63010216star spike
422--129387123767892021352891920.7998983412.63214412star spike
423--129387123767892021359438320.984140712.65177355shred galaxy <semiauto-found>
424--129387123767892075046504820.9009006512.92682801star spike
425--129387123767892075046504920.9010245912.92724944star spike
426--129387123767892075059620521.240782912.90292571shred galaxy <semiauto-found>
427--129387123764991843139597520.969923913.2948079--
428--129387123767886062819757421.4000493513.14267164--
429--129387123767892021352946420.7824603912.65422213--
430--129387123767892021372529821.2565268712.54367773star spike
431--129387123767886009126097121.1389049312.83061445--
432--129387123767892075066244021.355656112.86074531--

Load the catalogs of all NSA objects in the remove list and extract the flags for any of the targets that are actually in the remove list. Also get flag-related statistics for everything


In [8]:
#for remlist comparison
tojoin = {'OBJID': [], 'FLAGS': []}

# for "all" stats
allcount = 0
all_flag_counts = {(i+1):0 for i in range(64)}
flag_masks = {(i+1):np.array(1 << i) for i in range(64)}

# have to loop over NSAIDs to efficiently load the catalogs one at a time
remlist_ids = remlist['SDSS ID']
unsaids = np.unique(remlist['NSA'])
for i, nsanum in enumerate(unsaids):
    print('On NSA#', nsanum, 'which is', i+1, 'of', len(unsaids))
    sys.stdout.flush()
    
    fn = os.path.join(data_dir, 'sql_nsa{}.fits.gz'.format(nsanum))
    try:
        tab = table.Table.read(fn)

        # find just the remove list objects' prpoerties
        tab_matched = tab[np.in1d(tab['OBJID'], remlist_ids)]
        for key, lst in tojoin.items():
            lst.extend(tab_matched[key])
            
        #extract FLAGS statstics for *all* objects
        for i, mask in flag_masks.items():
            all_flag_counts[i] += np.sum((tab['FLAGS'].astype('uint64')&mask)!=0)
        allcount += len(tab)
        
    except FileNotFoundError:
        print('Did not find', fn, 'so skipping it')


On NSA# 32 which is 1 of 28
On NSA# 13927 which is 2 of 28
On NSA# 33446 which is 3 of 28
On NSA# 61945 which is 4 of 28
On NSA# 61954 which is 5 of 28
Did not find ../local_data/sql_nsa61954.fits.gz so skipping it
On NSA# 85746 which is 6 of 28
On NSA# 126115 which is 7 of 28
On NSA# 129237 which is 8 of 28
On NSA# 129387 which is 9 of 28
On NSA# 130625 which is 10 of 28
On NSA# 131531 which is 11 of 28
On NSA# 132339 which is 12 of 28
On NSA# 140594 which is 13 of 28
On NSA# 145729 which is 14 of 28
On NSA# 148734 which is 15 of 28
On NSA# 149781 which is 16 of 28
On NSA# 149977 which is 17 of 28
On NSA# 150238 which is 18 of 28
On NSA# 150307 which is 19 of 28
On NSA# 150340 which is 20 of 28
On NSA# 150578 which is 21 of 28
On NSA# 150877 which is 22 of 28
Did not find ../local_data/sql_nsa150877.fits.gz so skipping it
On NSA# 150887 which is 23 of 28
On NSA# 153017 which is 24 of 28
On NSA# 165536 which is 25 of 28
On NSA# 166035 which is 26 of 28
On NSA# 166313 which is 27 of 28
On NSA# -- which is 28 of 28
Did not find ../local_data/sql_nsa--.fits.gz so skipping it

Now combine the remove list table with the set of FLAGS we got above


In [9]:
if 'OBJID' in tojoin:
    tojoin['SDSS ID'] = tojoin.pop('OBJID') # rename for join
remwflags = table.join(remlist, table.Table(tojoin), join_type='left')
remwflags.show_in_notebook(display_length=10)


Out[9]:
<Table masked=True length=420>
row_indexHost NameNSASDSS IDTarg_RATarg_DeccommentFLAGS
187--165536123764872124891147221.57195-0.19887408----
159--1457291237648702984553095224.6328147-1.079987716part of main galaxy68987912960
181--1655361237648703519850685221.0636814-0.6259872282star spike105622104838420
178--1655361237648703519981589221.3734899-0.6247009016star spike105587745100124
179--1655361237648703519981596221.3687812-0.6257746866star spike105656498131036
180--1655361237648703519981597221.3682296-0.6248161704star spike105622104703324
165--1457291237648703521554658224.9393172-0.6272479811second part of merging galaxy105555532321040
177--1655361237648704056787393221.2368418-0.3005513682second part of merger35253360132112
175--1655361237648704057050408221.8626044-0.3057260505star spike439804919677184
176--1655361237648704057050409221.8638732-0.3042778795star spike281543964754176
184--1655361237648704593592350221.04456380.1834074187shred105622104313872
66Alice1405941237648720157081640180.221537681-0.921871703309shred of merger105622137864208
68Alice1405941237648720693690573179.609937665-0.550527341235minor shred35253360132880
62Alice1405941237648720693952627180.1647985-0.4952457719--105624251662608
186--1655361237648720712107151221.72266-0.49723079star spike281543964623104
183--1655361237648720712237085221.9461438-0.4536277413shred123179930619920
182--1655361237648720712237216221.9478746-0.5396548915second part of merger35253360001040
168--321237648721215684624145.574019-0.04952083427--545426755424528
188--1655361237648721248911470221.57098-0.19708001--527834603458836
173--321237648721752555558145.60687450.3191398133shred of star72444691118948624
167--321237648721752555641145.59153370.3097698893bit of larger galaxy105622137733136
169--321237648721752621091145.73059430.2511563101shred105622104313944
170--321237648721752621094145.73152470.2526045774shred35253393686616
171--321237648721752621095145.73159810.2471176378shred105656497602576
172--321237648721752621098145.73466780.2451407284shred246325232931160
185--1655361237648721785914433221.79083880.3153469899star spike281543964754176
111--129387123764991843133031020.6835110713.22485156star spike105622137868560
427--129387123764991843139597520.969923913.2948079--105624285347856
63Alice1405941237650371555623210179.881864-1.742935915--105656463917400
74--1405941237650371555819885180.315794624-1.73185028005star spike457465858756880
69--1405941237650372092559950180.0277199-1.31238173722--281543964754688
57Alice1405941237650762927570986180.2855078-1.441528804--105656497606928
61Alice1405941237650762927702028180.6098101-1.488209133--105555532316760
202--139271237651735220256810180.34613291.646593137sat trail263883059761500
196--139271237651735220387926180.72586061.483454464merger52845546177040
197--139271237651735220387927180.73115711.48206632merger35253360132368
192--139271237651735220388002180.68052311.59772897merger246359592665104
192--139271237651735220388002180.68052311.59772897merger246359592665104
190--139271237651735757324325180.79406511.962739469star spike123248684699992
194--139271237651735757324437180.85469251.942194355star52882053402640
200--139271237651736293999101180.37376382.343191394star spike316728370401552
201--139271237651736294129930180.69448692.401410663shred35255507620112
193--139271237651752936931426180.72836821.751243222merger35253360132112
191--139271237651752936931860180.82075891.771710573star spke281543964623104
195--139271237651752936997146180.91573551.722676637merger35255507620112
199--139271237651753473867954180.95314772.100966998merger105622137864208
198--139271237651753473867956180.95547882.100210169shred35253360136464
203--139271237651753473933551181.17334572.120110586star spike105553418912092
204--139271237651753473999601181.19064512.119739076star spike281543964623104
55Aeneid1487341237652935103676433310.0563008-5.785524714--316728370925844
54Aeneid1487341237652935103676437310.056789-5.7826849--246359626748180
53Aeneid1487341237652935103676444310.0543489-5.783606789--316659651449180
163--1457291237655499747164344224.1269892-1.265718049shred35253360136464
160--1457291237655693551796297224.2756439-0.9749176907star spike105622137868560
164--1457291237655693551796650224.2301133-0.9903793954second part of merging galaxy35253360001040
162--1457291237655693551796680224.3053977-0.9933273332second part of merging galaxy105622104313872
161--1457291237655693552058398224.8513685-0.9369250115star spike105656497602832
80Ulysses1503401237656906348167410344.1945902-0.9978173971--105624251662352
310--619451237657190902530119353.9507374-0.1327407029star spike105622137868560
41AnaK619451237657190902530122353.9476243-0.1356747--246359592669528
42AnaK619451237657190902858011354.571808-0.05123042--35253360132368
45AnaK619451237657191976599705354.62815120.680931245--105553418387728
157--132339123765758494998547839.68849299-0.9835482698tidal companion52845546176528
151--334461237657594075807758123.383968736.03845282misclassified galaxy35221147881488
150--334461237657594075807834123.458787736.09972888star spike105553418391824
147--334461237657594612613331122.9554636.13238905part of larger spiral105622104178704
152--334461237657594612678694123.058469236.34474181star shred123248650096912
148--334461237657594612809881123.254207736.53263262part of merger193617394274320
145--334461237657594612810071123.4271136.5753satellite trail72515059863654676
146--334461237657594612875394123.475821236.65209819satellite trail316728336847124
149--334461237657607497384178123.291112136.27196738star shred334253950898448
144--334461237657607497384510123.285753836.27676563likely tidal feature from primary457465825202448
9Hamlet1660351237658205598712218228.24702241.844161--281641205498184
10Hamlet1660351237658206135517869228.49870342.225523--281543964754176
103--132339123766002452103181739.46781726-1.143523316--263953959747600
388Narnia132339123766002452109790339.65634965-1.245097828shred galaxy <semiauto-found>316728370397456
389Narnia132339123766002452109790439.65383793-1.245492657shred galaxy <semiauto-found>316728370397456
155--132339123766002452116311839.6905191-1.240192027not there?527834602930452
140--857461237662223517811271149.267222632.97946985star spike281543964754176
7Hamlet1660351237662300829189130228.23465842.295864--281543964623104
5Hamlet1660351237662300829253651228.37479242.330362--316730484330768
11Hamlet1660351237662300829253653228.36943342.330579--387097081024784
4Hamlet1660351237662300829253654228.36882142.335368--35253360136536
2Hamlet1660351237662300829253660228.37358942.32577--105622137868304
6Hamlet1660351237662300829384720228.76335942.215231--105656497602648
16Hamlet1660351237662300829384723228.76249242.215609--105553418391568
1Hamlet1660351237662300829384725228.77829342.209718--105622137868632
3Hamlet1660351237662300829384730228.7595842.217655--175990848491792
14Hamlet1660351237662300829384747228.76406842.214973--105622137868304
13Hamlet1660351237662498391130169228.15162442.088901--105587778130192
0Hamlet1660351237662498391261226228.3895341.95437--105622104314640
12Hamlet1660351237662498391261232228.39969441.959533--105622137868632
15Hamlet1660351237662498391326725228.68125842.043465--263986173055320
8Hamlet1660351237662498928197694229.03846642.321874--105587779174744
37AnaK619451237663277925007626353.73395980.49841161--105553384833368
48AnaK619451237663277925204613354.19211690.6290792209--68987912448
39AnaK619451237663277925335175354.45441850.5714453306--263951778709776
300AnaK619451237663277925335177354.45215520.5717430743shred galaxy <semiauto-found>387099262058768
301AnaK619451237663277925335179354.45171040.5712535103shred galaxy <semiauto-found>474991472804112
302AnaK619451237663277925335851354.52824030.5343066278shred galaxy <semiauto-found>387097114444120
47AnaK619451237663277925467111354.78728450.454610128--281543964623104
46AnaK619451237663783657996411354.1831579-0.40931472--105622104314128
309--619451237663784194605204353.68434270.1278404295star spike105622138913112
44AnaK619451237663784194605286353.62844850.172251683--105624251798032
49AnaK619451237663784194670736353.8059040.03908026366shredded35253394210832
50AnaK619451237663784194670740353.81028390.04187874978shredded475058045321488
311--619451237663784194670743353.80825810.03515213013shred galaxy35253394210832
312--619451237663784194670744353.81409430.04030397733shred193583068610576
313--619451237663784194670746353.8074510.04944869333shred35253394210832
320--619451237663784194670752353.81244490.03589864126--404689301143568
314--619451237663784194670753353.80140940.0356422559shred35253360656656
315--619451237663784194670764353.80167270.04084519771shred1153097465424642320
316--619451237663784194670765353.81527830.04340013946shred105622138388496
43AnaK619451237663784194671628353.81375770.050898988--281543964623104
317--619451237663784194801795354.01619420.07986492997shred105587778125840
33AnaK619451237663784194801797354.0168290.0795873--105587778125912
35AnaK619451237663784194801799354.01711970.07785658--105587778125840
34AnaK619451237663784194801800354.0168150.0801771--105553384837464
303AnaK619451237663784194801801354.0175240.0744706829shred galaxy <semiauto-found>105553418387472
304AnaK619451237663784194801805354.01750180.0755611531shred galaxy <semiauto-found>105656497602832
305AnaK619451237663784194802608354.02214940.06986532704shred galaxy <semiauto-found>281640601387264
306AnaK619451237663784195063812354.61336670.2013047562star spike105622137864464
307AnaK619451237663784195064879354.61476770.1993252941star spike281543964754176
126--857461237664337706156587149.819014331.78134893star spike316730517750032
134--857461237664338242962147149.443839132.01556355star spike281543964623104
139--857461237664338243158155149.99937132.33227938star spike387097114579216
124--857461237664870826639438149.707217232.07231369spiral arm35253394735120
131--857461237664871363117423148.924726132.6575022star spike387099262058768
117--857461237664871900119158149.290510532.98970045star spike545426789503252
136--857461237664871900119164149.294681832.99411251star spike387097115103508
119--857461237664871900119173149.294922232.98741894star spike387028395626844
120--857461237664871900119174149.294148532.99387801star spike316728370925844
129--857461237664871900119180149.296621732.99089205star spike527765883982172
121--857461237664871900119181149.29514633.00088263star spike316728370925844
133--857461237664871900119191149.297614832.99248793star spike387028395626844
137--857461237664871900119194149.293845932.99678623star spike527834603458940
130--857461237664871900119327149.312128732.98504379star spike475058011246936
128--857461237664871900185217149.57259633.04764016star spike316728371446544
127--857461237664871900185220149.574856333.0488752star spike387097115623696
118--857461237664871900185482149.564488133.00609603star spike387028395102552
141--857461237664878879047806149.344354531.74616873merger tail246361740153176
142--857461237664878879375459150.264694832.17768562misclassified52845546176528
125--857461237664879415853949149.020942232.27440651star spike281572486021448
135--857461237664879415853951149.032456832.2377849star spike316730518798608
123--857461237664879416049673149.498323632.24372568HII region35253360136976
138--857461237664879416049782149.604985632.36700809shred1389817359368280
132--857461237664879416116195149.655250732.37535926star spike281544568738120
122--857461237664879416181033149.785170832.42598509star spike316728336847632
28Gilgamesh1663131237665565004858351233.970311216.09952538star spike281572485890376
27Gilgamesh1663131237665565004923042234.141235116.06926024star spike387097115103508
29Gilgamesh1663131237665565004924107234.146595216.05419875star spike281543964623104
22Gilgamesh1663131237665565541597382233.79912916.54718--35287719874904
18Gilgamesh1663131237665565541597386233.79856716.548445--35253393686544
21Gilgamesh1663131237665565541597393233.78881916.556174--35287719874832
24Gilgamesh1663131237665565541597394233.7881316.552901--105587778125912
19Gilgamesh1663131237665565541597396233.80135916.550769--246290906746968
308AnaK619451237666408439612143353.6516210.3872835173shred galaxy <semiauto-found>387030542586200
40AnaK619451237666408439873560354.12709990.28367036--72233584886420244
318--619541237666408439939228354.30801770.4087636396shred457465858756880
38AnaK619451237666408439939277354.34991430.3917256--175990848491792
36AnaK619451237666408439939280354.34940110.39667053--35253360136464
319--619451237666408440004744354.432580.3579006216--105622137864208
92--131531123766722768646974334.10685345.723417469HI region263953926193168
91--131531123766722822327526333.98183126.204009574shred246393952407896
101--131531123766722876021160434.172034426.562866184star spike246359592669968
96--131531123766722876021163734.172106786.572001036star spike246325266485592
97--131531123766722876021164434.171046816.572490431star spike387097114579288
93--131531123766722876021165234.169592856.570152826star spike246290906747224
98--131531123766722876021165634.171872546.580759921star spike105622137868632
99--131531123766722876021168634.178426676.570043726star spike545426788979032
20Gilgamesh1663131237667783928971283234.23803116.062159--105622137868560
26Gilgamesh1663131237667783928971359234.32401616.065865--105587778130264
31----1237668335783968924234.004120116.12301278star spike545426789503252
25Gilgamesh1663131237668336320774200234.00752416.765775--105553418391896
30Gilgamesh1663131237668336857579628234.005943717.09853327shred72163250501845080
23Gilgamesh1663131237668367995896029234.41787316.176608--545428936982876
90--131531123767001458298067233.333816275.756103586shred105622104310032
89--131531123767001458324288833.912211825.652888348star spike105622137868560
94--131531123767001458330838734.065399295.538636513star spike105587778130192
95--131531123767001511998269133.590264346.028925956star spike105656498651152
100--131531123767001512031037434.300197216.004875032shred105624251662864
65Alice1405941237674648854659334179.3826082-1.252963848shred of massive galaxy105589892059224
64Alice1405941237674648854659340179.3861043-1.258124142shred of massive galaxy105622137868304
67Alice1405941237674648854659347179.372884669-1.24092352087shred of spiral105622104314128
73--1405941237674648854855886179.817570821-1.11138864573shred of spiral105622104314128
58Alice1405941237674648854921317179.8642061-1.156301836--316728336847120
59Alice1405941237674649391857948180.1293214-0.695983535--387097081024784
71--1405941237674649391858392180.096191678-0.674222336493star spike316728371450128
72--1405941237674649391858693180.095856258-0.671956369284star spike281543964754176
70--1405941237674649391924335180.251138748-0.826766889108star spike439804919677184
60Alice1405941237674649391988842180.3622875-0.720470482--35253360136464
359--129237123767860185051968720.1397307617.34349851shred galaxy <semiauto-found>387099261927696
360--129237123767860185051968820.1374937617.34451981shred galaxy <semiauto-found>105624285216784
384--129237123767860185051970320.1575336917.34756677--457465859281172
361--129237123767860185065084020.4153651517.29491013noise artiface316730517881176
362--129237123767860185065084320.4176668417.29484872noise artiface457465858752784
363--129237123767860185065114420.3864418317.26723208shred galaxy <semiauto-found>439804919677184
364--129237123767860185071672220.6519778217.30235502noise artifact316730517881104
365--129237123767860185071672420.6526973817.30142806noise artifact457465858752784
366--129237123767860185078190020.7882226817.28792472noise artifact474989291770128
368--129237123767860185078190520.7781020517.29223071noise artifact457465858756880
369--129237123767860185078190720.7798775717.29033252noise artifact474989325324560
367--129237123767860185078196720.7883729417.28975247noise artifact474989325324560
370--129237123767860238732553520.0791964417.73512094shred galaxy <semiauto-found>387099262058768
371--129237123767860238745610220.2680762817.57900131shred galaxy <semiauto-found>105624285351952
385--129237123767860238745610720.262019217.57931846--105624285352208
372--129237123767860238745610820.2674686117.57739308shred galaxy <semiauto-found>545428936462608
373--129237123767860238745630420.3279058717.75338585shred galaxy <semiauto-found>246361740153176
383--129237123767860238752165420.4639224617.60621566--316728370401552
84--130625123767862223935918327.576034224.057899478shred of massive galaxy105624251797776
82--130625123767862223942476027.746856834.1817563bright star wing387097115103508
86--130625123767862277629608027.74785114.531434674star spike281573559632200
87--130625123767862331349416628.492548484.888903287double nucleus105624251797520
85--130625123767862331355961928.605500224.805294169shred of massive galaxy105622104314128
83--130625123767866197331173628.510195254.593321799moving object35191083107088
214--1508771237678777399247805348.1848074.681784804--281543964623104
211--1508871237678777399443486348.696744.636643778shred galaxy105622104313872
213--1508871237678777399443510348.72972824.716392095--105622137864208
210--1508871237678777399443945348.69570664.648493306shred galaxy105624285217040
224--1508871237678777399509169348.87547074.614633999shred galaxy <semiauto-found>35253360136976
225--1508871237678777399509171348.87488974.612996446shred galaxy <semiauto-found>246293054226448
212--1508871237678777399509172348.87128274.613763855--105622137864280
228--1508871237678777399509173348.87177264.614206034shred galaxy <semiauto-found>105622137864208
229--1508871237678777399509174348.87255084.612810864shred galaxy <semiauto-found>1231556404445528
226--1508871237678777399509175348.87331244.616120286shred galaxy <semiauto-found>246290906743128
227--1508871237678777399509177348.87562474.612707788shred galaxy <semiauto-found>105622137864208
230--1508871237678777399509179348.86938024.613929468shred galaxy <semiauto-found>105622137864280
332--1499771237678857925689519339.035452610.3559813--105553418391824
322--1499771237678857925886378339.382812110.31307952shred galaxy <semiauto-found>316730517881104
323--1499771237678857926017517339.685495210.47260362shred galaxy <semiauto-found>387099262058768
324--1499771237678858462626161339.060107710.6498927shred galaxy <semiauto-found>334320556445784
329--1499771237678858462691406339.277510410.66412562--105622137868560
325--1499771237678858462757207339.467882210.7531606shred galaxy <semiauto-found>35186788139280
326--1499771237678858462757209339.46728110.75221466shred galaxy <semiauto-found>387097114575120
327--1499771237678858462757432339.349211510.83567213shred galaxy <semiauto-found>316728370266384
330--1499771237678858462822803339.582717210.85063655--105624285352464
257--1505781237678859539448025346.143610812.26060821noise artifact72374322408329488
258--1505781237678859539448026346.143275912.26198846noise artifact457465858757392
259--1505781237678859539710417346.736889512.17143482shred galaxy <semiauto-found>105624251662680
260--1505781237678860076515632346.681876912.5783213shred galaxy <semiauto-found>35186788143192
431--129387123767886009126097121.1389049312.83061445--105553419436376
419--129387123767886009126116221.2378709912.85534644shred galaxy <semiauto-found>35219033948504
110--129387123767886062819740721.3338888213.11025026shred of larger galaxy105553384837136
428--129387123767886062819757421.4000493513.14267164--527836750417936
156--132339123767888103787735439.47088333-1.664176936tidal tail of larger galaxy263951778713872
391Narnia132339123767888103787735639.46929951-1.6622428shred galaxy <semiauto-found>105622137733136
392Narnia132339123767888103787735839.46676407-1.660034245shred galaxy <semiauto-found>316728370397528
393Narnia132339123767888103787736139.46445312-1.659262884shred galaxy <semiauto-found>387097114579216
394Narnia132339123767888103787736239.4676998-1.659933653shred galaxy <semiauto-found>316728370401552
390Narnia132339123767888103787736439.46768799-1.667585459shred galaxy <semiauto-found>105624285351952
395Narnia132339123767888103794300739.62430852-1.760352276shred galaxy <semiauto-found>105624285352208
104--132339123767888157494485439.86604461-1.277385371shred105622104313872
397--132339123767889013748537239.49555231-1.517742273star spike387028395098384
396--132339123767889013755149939.6108927-1.430396371--316728337371412
262--1505781237678920198783047346.222545112.30378529--35253394735120
263--1505781237678920198783050346.216518712.30575485--105622138912784
264--1505781237678920198783058346.213368812.31512696--105553419436048
265--1505781237678920198783068346.225295712.3005798--105622138916880
261--1505781237678920198979824346.714555512.34642846shred galaxy <semiauto-found>105624251793680
420--129387123767892021352887620.7049319812.57925603shred galaxy <semiauto-found>387097114444048
421--129387123767892021352891620.7993195212.63010216star spike316730517885200
422--129387123767892021352891920.7998983412.63214412star spike316730517885200
429--129387123767892021352946420.7824603912.65422213--387097080889616
423--129387123767892021359438320.984140712.65177355shred galaxy <semiauto-found>316728370397456
430--129387123767892021372529821.2565268712.54367773star spike246359627268368
109--129387123767892021372551221.2023199512.54237176star spike316661764718936
424--129387123767892075046504820.9009006512.92682801star spike105622137868560
425--129387123767892075046504920.9010245912.92724944star spike105622137868560
112--129387123767892075059614521.3214761513.01961332star spike105587778130192
113--129387123767892075059614621.3206270413.01532781star spike123179964174680
114--129387123767892075059614721.3207833513.01596598star spike105656497607000
426--129387123767892075059620521.240782912.90292571shred galaxy <semiauto-found>105622137733392
115--129387123767892075066173621.3985061712.89799881star spike105656498651408
432--129387123767892075066244021.355656112.86074531--422283130835272
215--1508771237679005021700191348.2595014.508406536--387097114579216
231--1508871237679005021700193348.26275984.511024978shred galaxy <semiauto-found>387097114579216
254--1508871237679005021700194348.2585524.51987099--175990882046040
232--1508871237679005021700198348.26275294.511561979shred galaxy <semiauto-found>457465858756880
233--1508871237679005021700288348.39425034.552772309shred galaxy <semiauto-found>105624251797776
255--1508871237679005021700289348.39177684.557667469--105624285348112
235--1508871237679005021700292348.39349944.55007271shred galaxy <semiauto-found>387099262058768
234--1508871237679005021700293348.39500394.55037932shred galaxy <semiauto-found>105656497602904
236--1508871237679005021765925348.39947024.567074821shred galaxy <semiauto-found>387099262062864
237--1508871237679005021765929348.39974194.567842711shred galaxy <semiauto-found>246359626223632
238--1508871237679005021831464348.62079264.378087317shred galaxy <semiauto-found>105555565875544
239--1508871237679005021962537348.94709924.53092546shred galaxy <semiauto-found>35287753294168
240--1508871237679005022028541349.06508254.497889621star spike281545105609032
241--1508871237679005022028542349.06690654.496766323star spike281543964623104
242--1508871237679005558636613348.46313564.904934826shred galaxy <semiauto-found>246359626223632
216--1508771237679005558636614348.46362734.905022479shred galaxy35253393690896
253--1508871237679005558636614348.46362734.905022479--35253393690896
243--1508871237679005558636616348.46348464.907482859shred galaxy <semiauto-found>35253393690896
244--1508871237679005558636619348.46120454.90438764shred galaxy <semiauto-found>387097114579216
245--1508871237679005558636621348.4607034.904467179shred galaxy <semiauto-found>387097114578960
246--1508871237679005558636865348.47903584.884018334shred galaxy <semiauto-found>387099261927696
247--1508871237679005558637017348.39964374.866732323shred galaxy <semiauto-found>387097114443792
248--1508871237679005558637018348.39978224.867484181shred galaxy <semiauto-found>105622137733392
249--1508871237679005558702453348.6501224.877933283shred galaxy <semiauto-found>105624285216784
250--1508871237679005558767960348.68950734.922046477shred galaxy <semiauto-found>105622137733392
251--1508871237679005558833483348.89577854.834275971shred galaxy <semiauto-found>387099262058768
252--1508871237679005558833491348.93716164.915840214shred galaxy <semiauto-found>105622104310104
328--1499771237679010927476977339.677574910.20942277shred galaxy <semiauto-found>d105622104314128
331--1499771237679010927476978339.674464610.21052549--105624285216784
218--129237123767916930465797020.2322414217.49849757star spike527834602934544
375--129237123767916930465823420.2573862617.36696414shred galaxy <semiauto-found>263951812264208
376--129237123767916930472355620.4193567217.38219709shred galaxy <semiauto-found>105622137864280
377--129237123767916930472389820.4486251217.34729588noise artifact316730517885712
378--129237123767916930472389920.4499280217.34804584noise artifact474989325324560
374--129237123767916930478902120.5357396517.5275968shred galaxy <semiauto-found>72303987990331736
379--129237123767916930485518020.7601614717.33295831star spike281543964623104
380--129237123767916930485518420.761778717.33254073star spike281543964623104
386--129237123767916930492023820.8023223917.32114579--316728370397456
381--129237123767916984146396420.1470021517.84462893shred galaxy <semiauto-found>281640601387264
219--129237123767916984152890120.3092414117.81300887star spike105553418387728
382--129237123767916984172567420.7745992417.88975939shred galaxy <semiauto-found>105622137864536
334--15301712376795037820519040.0356566893119.9648746shred galaxy <semiauto-found>457465825202448
335--1530171237679504318857642359.884309420.47951372shred galaxy <semiauto-found>387099262058768
336--15301712376795043191851190.743337181220.38574162shred galaxy <semiauto-found>246359626223632
336--15301712376795043191851190.743337181220.38574162shred galaxy <semiauto-found>246359626223632
399--12611512376795043191851190.743337181220.38574162shred galaxy <semiauto-found>246359626223632
399--12611512376795043191851190.743337181220.38574162shred galaxy <semiauto-found>246359626223632
414--12611512376795043192505680.905597703620.46176508--527834602935056
400--12611512376795043194471901.42244761820.47680278shred galaxy <semiauto-found>105622138912784
401--12611512376795043194471911.42050157120.48091637shred galaxy <semiauto-found>387097115623696
405--12611512376795043194471941.41833711220.47936111shred galaxy <semiauto-found>105622138913040
408--12611512376795043194471961.41691702720.47842819shred galaxy <semiauto-found>105622138917136
406--12611512376795043194471971.41783293320.47970895shred galaxy <semiauto-found>387097115627792
402--12611512376795043194471981.42174266320.47824808shred galaxy <semiauto-found>105622138913040
403--12611512376795043194471991.41947719820.48001451shred galaxy <semiauto-found>474989326373648
404--12611512376795043195126861.42328040520.47842523shred galaxy <semiauto-found>105622138388756
407--12611512376795043195126871.42255351220.48171438shred galaxy <semiauto-found>105622138392852
409--12611512376795048559904160.50067313420.98720461shred galaxy <semiauto-found>246359626223888
409--12611512376795048559904160.50067313420.98720461shred galaxy <semiauto-found>246359626223888
337--15301712376795048559904160.50067313420.98720461shred galaxy <semiauto-found>246359626223888
337--15301712376795048559904160.50067313420.98720461shred galaxy <semiauto-found>246359626223888
338--15301712376795048559904210.498317579720.9870445shred galaxy <semiauto-found>105622137869072
338--15301712376795048559904210.498317579720.9870445shred galaxy <semiauto-found>105622137869072
410--12611512376795048559904210.498317579720.9870445shred galaxy <semiauto-found>105622137869072
410--12611512376795048559904210.498317579720.9870445shred galaxy <semiauto-found>105622137869072
411--12611512376795048559904220.50052828720.98757402shred galaxy <semiauto-found>105622137864208
411--12611512376795048559904220.50052828720.98757402shred galaxy <semiauto-found>105622137864208
339--15301712376795048559904220.50052828720.98757402shred galaxy <semiauto-found>105622137864208
339--15301712376795048559904220.50052828720.98757402shred galaxy <semiauto-found>105622137864208
206--1497811237679996084551744335.8068201-3.40787382shredded star545426755424528
275--1497811237679996084617231335.9158625-3.42887141--263951813840916
272OBrother1497811237679996084617518335.9804361-3.269670748shred galaxy <semiauto-found>387097114575120
267OBrother1497811237679996084617615336.0424634-3.307055428shred galaxy satellite/art457465859281172
268OBrother1497811237679996084617622336.0430875-3.308617331shred galaxy satellite/art316728370925844
269OBrother1497811237679996084617623336.0425695-3.307294956shred galaxy satellite/art316728370925844
270OBrother1497811237679996084682961336.1307846-3.245994227shred galaxy <semiauto-found>246361773707536
271OBrother1497811237679996084682967336.1282107-3.246489876shred galaxy <semiauto-found>105624285351952
207--1497811237679996084683042336.2046149-3.37285556shredd galaxy35287753294168
273OBrother1497811237679996084748653336.2398127-3.341441367shred galaxy <semiauto-found>105624285347856
78Iliad1502381237680064809861229342.7393734-5.56160845--387099228504336
77Iliad1502381237680064809927114342.8918986-5.610564608--105624285217040
279--1503071237680064810516514344.3068532-5.696343271shred galaxy <semiauto-found>193583068086288
278--1503071237680064810516520344.306711-5.695469shred galaxy <semiauto-found>105622137864464
280--1503071237680064810516695344.2352586-5.536600883noise artifact387097114579216
281--1503071237680064810516699344.2333971-5.535562918noise artifact316728370401552
296--1503071237680065347059811343.6112483-5.233760003--72163181783028060
296--1503071237680065347059811343.6112483-5.233760003--72163181783028060
297--1503071237680065347256732344.0239496-5.158834491--281475245146368
274OBrother1497811237680066954461498336.2339279-3.663585155shred galaxy <semiauto-found>105622137868304
282--1503071237680116342128690343.8288738-5.735896191scattered light artifact35253360661012
282--1503071237680116342128690343.8288738-5.735896191scattered light artifact35253360661012
284--1503071237680116342128709343.8353918-5.727860568scattered light artifact105622138392596
284--1503071237680116342128709343.8353918-5.727860568scattered light artifact105622138392596
283--1503071237680116342128732343.8294351-5.733418471scattered light artifact1301856429674844
283--1503071237680116342128732343.8294351-5.733418471scattered light artifact1301856429674844
285--1503071237680116342128739343.8346146-5.727728845scattered light artifact105622138392852
285--1503071237680116342128739343.8346146-5.727728845scattered light artifact105622138392852
286--1503071237680116342128742343.834265-5.722005562scattered light artifact105553418916116
286--1503071237680116342128742343.834265-5.722005562scattered light artifact105553418916116
288--1503071237680116342128743343.8419344-5.72585195scattered light artifact105622138392852
288--1503071237680116342128743343.8419344-5.72585195scattered light artifact105622138392852
290--1503071237680116342128744343.8361263-5.71889325scattered light artifact105622138392852
290--1503071237680116342128744343.8361263-5.71889325scattered light artifact105622138392852
287--1503071237680116342128746343.8336776-5.722660551scattered light artifact105622138392852
287--1503071237680116342128746343.8336776-5.722660551scattered light artifact105622138392852
289--1503071237680116342128750343.8426963-5.72754652scattered light artifact105622138392852
289--1503071237680116342128750343.8426963-5.72754652scattered light artifact105622138392852
291--1503071237680116342128763343.8362465-5.716902124scattered light artifact105553418916116
291--1503071237680116342128763343.8362465-5.716902124scattered light artifact105553418916116
292--1503071237680116342128767343.8349104-5.717821607scattered light artifact105622138392852
292--1503071237680116342128767343.8349104-5.717821607scattered light artifact105622138392852
293--1503071237680116879130861344.1317102-5.316218827shred galaxy <semiauto-found>105624285217296
294--1503071237680116879196393344.2601029-5.500090538shred galaxy <semiauto-found>105622137733392
295--1503071237680116879196394344.2611265-5.499761497shred galaxy <semiauto-found>316728336847120
208--1497811237680192048726285335.7671939-3.45669501shred galaxy316728370397456
107--12611512376802468147365220.801696159620.33184714moving object175928571461904
107--12611512376802468147365220.801696159620.33184714moving object175928571461904
340--15301712376802468147368520.789950039920.35910528shred galaxy <semiauto-found>246396133441624
340--15301712376802468147368520.789950039920.35910528shred galaxy <semiauto-found>246396133441624
412--12611512376802468147368520.789950039920.35910528shred galaxy <semiauto-found>246396133441624
412--12611512376802468147368520.789950039920.35910528shred galaxy <semiauto-found>246396133441624
341--1530171237680247351083137359.463925720.69770568shred galaxy <semiauto-found>316730517884944
342--1530171237680247351083138359.464152520.69737833shred galaxy <semiauto-found>527836750414096
343--1530171237680247351083141359.464556320.6969454shred galaxy <semiauto-found>316730517884944
356--1530171237680247351214130359.863776120.75131601--105553418915860
355--1530171237680247351214677359.869876620.74238491--281543964623104
344--15301712376802473515420390.599304111220.68166076shred galaxy <semiauto-found>527836750413840
344--15301712376802473515420390.599304111220.68166076shred galaxy <semiauto-found>527836750413840
413--12611512376802473515420390.599304111220.68166076shred galaxy <semiauto-found>527836750413840
413--12611512376802473515420390.599304111220.68166076shred galaxy <semiauto-found>527836750413840
415--12611512376802473516729710.983559886420.74143047--35253394739472
416--12611512376802473516729791.01099042520.76383535--316728371450128
417--12611512376802473516729921.01411603220.76592848--387097115627792
345--1530171237680247888019633359.679552621.14766092shred galaxy <semiauto-found>105624285351952
357--1530171237680247888019634359.672929521.14081159--175990882046224
348--1530171237680247888019636359.674752521.1417034shred galaxy <semiauto-found>387097114579216
347--1530171237680247888019639359.676798921.14948469shred galaxy <semiauto-found>105622137868560
346--1530171237680247888019640359.677529321.14773798shred galaxy <semiauto-found>105624285348112
349--1530171237680247888085341359.799624621.01209401noise artifact281543964623104
350--1530171237680247888085471359.798221621.01104915noise artifact281543964623104
106--12611512376802478884786180.759831098921.00467809noise near bright star299067431321856
106--12611512376802478884786180.759831098921.00467809noise near bright star299067431321856
351--1530171237680296744255765359.953639521.16115858star spike105622138392596
352--1530171237680296744255771359.953367821.16272591star spike387097115104020
353--1530171237680296744255773359.952906621.16394053star spike387097115103508
354--1530171237680296744255774359.952492221.16655599star spike387097115103252

Convert FLAGS value to how many objects have specific bits set

Note that "bit #1" is the 0th bit (in python indexing)


In [10]:
flags = remwflags['FLAGS']
flags = flags[~flags.mask].view(np.ndarray).astype('uint64')

bitcounts = {}
for i in range(64):
    bitmask = np.array(1 << i, dtype='uint64')
    bitcounts[i+1] = np.sum((flags & bitmask) != 0)
    
bitcounttable = table.Table(data=[list(bitcounts.values()), list(bitcounts.keys())], names=['count', 'bit'])

Now get the description of each bit from SDSS SQL and combine that with the Counts from above


In [22]:
# this SQL query gets the meaning of the flags
qry = urllib.parse.urlencode({'cmd': 'SELECT * FROM PhotoFlags', 'format': 'csv'})

url = 'http://skyserver.sdss.org/dr12/en/tools/search/x_sql.aspx?' + qry
csv = urllib.request.urlopen(url).read()

In [26]:
names = []
descrs = []
bits = []
# now we hand-parse it to get the bit field right
rows = csv.split(b'\n')
for row in rows[2:]:  #skip the "Table1" and the header
    if row.strip() == b'':
        continue
        
    spl = row.split(b',')
    name, val = spl[:2]
    descr = b','.join(spl[2:])
    
    names.append(name)
    descrs.append(descr)
    
    intval = int(val, 0)
    for i in range(65):
        if (intval >> i)==0:
            bits.append(i)
            break
    else:
        raise ValueError('value {} doesnt seem to be valid'.format(intval))

bittable = table.Table(data=[bits, names, descrs], names=['bit', 'name', 'description'])
bittable = table.join(bittable, bitcounttable)

Now add some comparison statistics


In [34]:
bittable['frac_rem'] = bittable['count']/len(remwflags)
bittable['frac_all'] = np.array([all_flag_counts[bitnum] for bitnum in bittable['bit']])/allcount
bittable['rem_to_all'] =  bittable['frac_rem']/bittable['frac_all']
bittable['rem_to_all'][np.isnan(bittable['rem_to_all'])] = -1


/Users/erik/anaconda3/envs/py3working/lib/python3.5/site-packages/ipykernel/__main__.py:3: RuntimeWarning: invalid value encountered in true_divide
  app.launch_new_instance()

In [35]:
bittable.sort('count')
bittable.reverse()
bittable.show_in_notebook(display_length=10)


Out[35]:
<Table length=64>
bitnamedescriptioncountfrac_remfrac_allrem_to_all
29BINNED1Object was detected in 1x1 binned image4190.9976190476190.9780024662111.02005780362
5CHILDObject is the product of an attempt to deblend a BLENDED object.3800.9047619047620.3227451955182.80333190804
46DEBLENDED_AT_EDGE"An object close enough to the edge of the frame normally not deblended, is deblended anyway. Only set for objects large enough to be EDGE in all fields/strips."3800.9047619047620.3227690778032.8031244843
18INTERPObject contains one or more pixels whose values were determined by interpolation.3630.8642857142860.4920428126511.75652543247
37STATIONARYThis object was consistent with being stationary.3410.8119047619050.8880198661620.914286710064
9NOPETRONo valid Petrosian radius was found for this object.3020.7190476190480.796548278770.902704378645
26DEBLENDED_AS_PSFDeblender treated obj as PSF2740.6523809523810.133689618034.87981761034
47DEBLEND_NOPEAKThere was no detected peak within this child in at least one band.2640.6285714285710.1323015211554.75105216541
13COSMIC_RAYContains a pixel interpreted to be part of a cosmic ray.2230.5309523809520.1740453178543.05065592973
49TOO_FEW_GOOD_DETECTIONSA child of this object had too few good detections to be deblended as moving.1610.3833333333330.4643968748320.825443395741
48PSF_FLUX_INTERPGreater than 20% of the PSF flux is from interpolated pixels.960.2285714285710.1763940674461.29579997718
32MOVEDThe deblender identified this object as possibly moving.890.2119047619050.1754777675431.20758751876
4BLENDEDObject had multiple peaks detected within it; was thus a candidate to be a deblending parent.860.2047619047620.07938422696942.57937769981
7NODEBLEND"No deblending was attempted on this object, even though it is BLENDED."860.2047619047620.07938422696942.57937769981
20NOTCHECKED"There are pixels in the object which were not checked to see if they included a local peak, such as cores of saturated stars."690.1642857142860.01875344221718.76029650366
3EDGEObject is too close to edge of frame630.150.013142080098311.4137182911
36BAD_MOVING_FITMoving fit too poor to be believable.510.1214285714290.0368318443463.29683657131
45INTERP_CENTERObject center is close to at least one interpolated pixel.430.1023809523810.1344787082120.761317190967
21SUBTRACTEDThis BRIGHT object had its wings subtracted from the frame280.06666666666670.02781750035342.39657287031
10MANYPETROMore than one Petrosian radius was found.270.06428571428570.1930483055760.333003255811
57MAYBE_CRThere is reasonable suspicion that this object is actually a cosmic ray.80.01904761904760.0153821409251.23829440521
27DEBLEND_PRUNEDAt least one child was removed because its image was too similar to a supposedly different child.70.01666666666670.03465124553430.480983191504
34NODEBLEND_MOVINGA MOVED object that the deblender did not treat as moving.60.01428571428570.07682248638950.185957457993
35TOO_FEW_DETECTIONSA child of this object was not detected in enough bands to reliably deblend as moving.60.01428571428570.03136913726460.455406668191
30BINNED2"Object was detected in 2x2 binned image, after unbinned detections are replaced by background."60.01428571428570.02815526409420.507390526969
51DEBLEND_DEGENERATETwo or more candidate children were essentially identical; one one was retained.40.009523809523810.00086414879150811.0210297317
33DEBLENDED_AS_MOVINGA MOVED object that the deblender treated as moving.40.009523809523810.01513259541950.629357308499
31BINNED4Object was detected in 4x4 binned image30.007142857142860.001344718847025.31178480816
38PEAKS_TOO_CLOSE"At least some peaks within this object were too close to be deblended, thus they were merged into a single peak."30.007142857142860.05670385479570.125967752432
61OBJECT2_DEBLEND_PEEPHOLEDeblend was modified by the deblender's peephole optimiser.10.002380952380950.0003236293274467.35703528399
6PEAKCENTER"Given center is position of peak pixel, rather than based on the maximum-likelihood estimator."10.002380952380950.005702017321970.417563161687
22NOSTOKESObject has no measured Stokes params00.00.0-1.0
2BRIGHT"Object detected in first, bright object-finding; generally r*<17.5"00.00.0-1.0
1CANONICAL_CENTER"Measurements used the center in r*, rather than the locally determined center."00.00.0-1.0
58MAYBE_EGHOSTThere is reasonable suspicion that this object is actually a ghost produced by the CCD electronics.00.00.001725860615190.0
8NOPROFILEObject was too small or too close to the edge to estimate a radial profile.00.00.0-1.0
17INCOMPLETE_PROFILEPetrosian radius intersects the edge of the frame.00.00.0-1.0
16BAD_RADIALSome of the points in the given radial profile have negative signal-to-noise ratio. Not a significant parameter.00.00.0-1.0
15MANYR90Object has more than one 90% light radius.00.00.0-1.0
14MANYR50Object has more than one 50% light radius.00.00.0-1.0
12DEBLEND_TOO_MANY_PEAKSThere were more than 25 peaks in this object to deblend; deblended brightest 25.00.09.7478713086e-070.0
64RESERVEDNot used00.00.0-1.0
23BADSKYThe sky level is so bad that the highest pixel in the object is very negative; far more so than a mere non-detection. No further analysis is attempted.00.00.0-1.0
24PETROFAINT"At least one possible Petrosian radius was rejected as the surface brightness at r_P was too low. If NOPETRO is not set, a different, acceptable Petrosian radius was found."00.00.0-1.0
62GROWN_MERGEDGrowing led to a merger00.00.0-1.0
60OBJECT2_HAS_SATUR_DNThe electrons in this saturated object's bleed trails have been included in its estimated flux.00.00.0-1.0
59NOTCHECKED_CENTERThe center of this object lies in a region that was not searched for objects.00.00.0-1.0
11NOPETRO_BIGPetrosian radius is beyond the last point in the radial profile.00.00.0-1.0
55AMOMENT_SHIFT"Centroid shift too large when measuring adaptive moments. Row/Column shifts are reported in mE1, mE2."00.00.0-1.0
19SATURATEDObject contains one or more saturated pixels00.00.05012745341740.0
54AMOMENT_FAINTObject was too faint to measure weighted moments such as mE1_g; unweighted values are reported.00.00.0-1.0
53CANONICAL_BANDThis is the 'canonical' band; r unless the object is undetected in the r filter.00.00.0-1.0
52BRIGHTEST_GALAXY_CHILDThis child is the brightest family member (in this band) that is classified as a galaxy.00.00.0-1.0
50CENTER_OFF_AIMAGE"At least one peak's center lay off of the atlas image. This can happen when the object is deblended as moving, or if the astrometry is bad."00.02.43696782715e-060.0
44SATUR_CENTERObject center is close to at least one saturated pixel.00.00.009941366554080.0
43DEBLEND_UNASSIGNED_FLUX"After deblending, a significant fraction of flux was not assigned to any children."00.00.0-1.0
42BAD_MOVING_FIT_CHILD"A possible moving child's velocity fit was too poor, so it was discarded and the parent was not deblended as moving."00.00.0248838784830.0
41BAD_COUNTS_ERRORAn object containing interpolated pixels had too few good pixels to form a reliable estimate of its error; the quoted error may be underestimated.00.00.0-1.0
40LOCAL_EDGECenter in at least one band is too close to an edge.00.00.0-1.0
39MEDIAN_CENTERCenter given is of median-smoothed image.00.00.0-1.0
63HAS_CENTERObject has a canonical center00.00.0-1.0
28ELLIPFAINT"Object center is fainter than the isophote whose shape is desired, so the isophote properties are not measured. Also flagged if profile is incomplete."00.00.0-1.0
56AMOMENT_MAXITERMaximum number of iterations exceeded measuring e.g. mE2_g; unweighted values are reported.00.00.0-1.0
25TOO_LARGE"The object is too large for us to measure its profile (it extends beyond a radius of approximately 260), or at least one child is larger than half a frame."00.09.7478713086e-070.0

In [ ]: